1 -- phpMyAdmin SQL Dump
2 -- version 4.3.11
3 -- http://www.phpmyadmin.net
4 --
5 -- Host: 127.0.0.1
6 -- Generation Time: Jun 02, 2019 at 03:48 AM
7 -- Server version: 5.6.24
8 -- PHP Version: 5.6.8
9
10 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11 SET time_zone = "+00:00";
12
13
14 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17 /*!40101 SET NAMES utf8 */;
18
19 --
20 -- Database: `datbancafe2`
21 --
22
23 -- --------------------------------------------------------
24
25 --
26 -- Table structure for table `admin`
27 --
28
29 CREATE TABLE IF NOT EXISTS `admin` (
30 `id` int(11) NOT NULL,
31 `username` varchar(255) NOT NULL,
32 `password` varchar(255) NOT NULL
33 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
34
35 --
36 -- Dumping data for table `admin`
37 --
38
39 INSERT INTO `admin` (`id`, `username`, `password`) VALUES
40 (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e');
41
42 -- --------------------------------------------------------
43
44 --
45 -- Table structure for table `basket`
46 --
47
48 CREATE TABLE IF NOT EXISTS `basket` (
49 `id` int(11) NOT NULL,
50 `customer_name` varchar(255) NOT NULL,
51 `contact_number` varchar(255) NOT NULL,
52 `address` varchar(255) CHARACTER SET utf8 NOT NULL,
53 `email` varchar(255) NOT NULL,
54 `total` varchar(255) NOT NULL,
55 `status` varchar(255) NOT NULL,
56 `date_made` varchar(255) NOT NULL
57 ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
58
59 --
60 -- Dumping data for table `basket`
61 --
62
63 -- --------------------------------------------------------
64
65 --
66 -- Table structure for table `contact`
67 --
68
69 CREATE TABLE IF NOT EXISTS `contact` (
70 `id` int(11) NOT NULL,
71 `customer_name` varchar(255) NOT NULL,
72 `subject` varchar(255) NOT NULL,
73 `email` varchar(255) NOT NULL,
74 `message` text NOT NULL
75 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
76
77 --
78 -- Dumping data for table `contact`
79 --
80
81 -- --------------------------------------------------------
82
83 --
84 -- Table structure for table `food`
85 --
86
87 CREATE TABLE IF NOT EXISTS `food` (
88 `id` int(11) NOT NULL,
89 `food_name` varchar(255) NOT NULL,
90 `food_category` varchar(255) NOT NULL,
91 `food_price` varchar(255) NOT NULL,
92 `food_description` text NOT NULL
93 ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;
94
95 --
96 -- Dumping data for table `food`
97 --
98
99 -- --------------------------------------------------------
100
101 --
102 -- Table structure for table `globals`
103 --
104
105 CREATE TABLE IF NOT EXISTS `globals` (
106 `global_id` int(11) NOT NULL,
107 `global_amt` varchar(255) NOT NULL
108 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
109
110 --
111 -- Dumping data for table `globals`
112 --
113
114 INSERT INTO `globals` (`global_id`, `global_amt`) VALUES
115 (1, '11');
116
117 -- --------------------------------------------------------
118
119 --
120 -- Table structure for table `items`
121 --
122
123 CREATE TABLE IF NOT EXISTS `items` (
124 `item_id` int(11) NOT NULL,
125 `order_id` varchar(100) NOT NULL,
126 `food` varchar(100) NOT NULL,
127 `qty` varchar(100) NOT NULL
128 ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
129
130 --
131 -- Dumping data for table `items`
132 --
133
134 -- --------------------------------------------------------
135
136 --
137 -- Table structure for table `reservation`
138 --
139
140 CREATE TABLE IF NOT EXISTS `reservation` (
141 `reserve_id` int(11) NOT NULL,
142 `no_of_guest` varchar(100) NOT NULL,
143 `email` varchar(100) NOT NULL,
144 `phone` varchar(100) NOT NULL,
145 `date_res` varchar(100) NOT NULL,
146 `time` varchar(100) NOT NULL,
147 `suggestions` varchar(100) NOT NULL
148 ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
149
150 --
151 -- Dumping data for table `reservation`
152 --
153
154 --
155 -- Indexes for dumped tables
156 --
157
158 --
159 -- Indexes for table `admin`
160 --
161 ALTER TABLE `admin`
162 ADD PRIMARY KEY (`id`);
163
164 --
165 -- Indexes for table `basket`
166 --
167 ALTER TABLE `basket`
168 ADD PRIMARY KEY (`id`);
169
170 --
171 -- Indexes for table `contact`
172 --
173 ALTER TABLE `contact`
174 ADD PRIMARY KEY (`id`);
175
176 --
177 -- Indexes for table `food`
178 --
179 ALTER TABLE `food`
180 ADD PRIMARY KEY (`id`);
181
182 --
183 -- Indexes for table `globals`
184 --
185 ALTER TABLE `globals`
186 ADD PRIMARY KEY (`global_id`);
187
188 --
189 -- Indexes for table `items`
190 --
191 ALTER TABLE `items`
192 ADD PRIMARY KEY (`item_id`);
193
194 --
195 -- Indexes for table `reservation`
196 --
197 ALTER TABLE `reservation`
198 ADD PRIMARY KEY (`reserve_id`);
199
200 --
201 -- AUTO_INCREMENT for dumped tables
202 --
203
204 --
205 -- AUTO_INCREMENT for table `admin`
206 --
207 ALTER TABLE `admin`
208 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
209 --
210 -- AUTO_INCREMENT for table `basket`
211 --
212 ALTER TABLE `basket`
213 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=26;
214 --
215 -- AUTO_INCREMENT for table `contact`
216 --
217 ALTER TABLE `contact`
218 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
219 --
220 -- AUTO_INCREMENT for table `food`
221 --
222 ALTER TABLE `food`
223 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=27;
224 --
225 -- AUTO_INCREMENT for table `globals`
226 --
227 ALTER TABLE `globals`
228 MODIFY `global_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
229 --
230 -- AUTO_INCREMENT for table `items`
231 --
232 ALTER TABLE `items`
233 MODIFY `item_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=15;
234 --
235 -- AUTO_INCREMENT for table `reservation`
236 --
237 ALTER TABLE `reservation`
238 MODIFY `reserve_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
239 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
240 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
241 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;